UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jpCdfNaMgexPiYhxhzKTDtuiT6pC256eQaDi0k0fYTQ='
WHERE
key_id = 'b54163c7c8d1c6ee9acd07b623b0c1b01f7c79a54b77f2ad04c546f641fe8d27'
AND (
token = 'jpCdfNaMgexPiYhxhzKTDtuiT6pC256eQaDi0k0fYTQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)