UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQxm7Lp0xM5g8GjGWAKeHejvlvV3Uo24rsglznZbxl8='
WHERE
key_id = '9300eadb5f0c8f2a9dcacbda8c9e02ec0568d1aa73792480ce503a7cdc388895'
AND (
token = 'hQxm7Lp0xM5g8GjGWAKeHejvlvV3Uo24rsglznZbxl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)