UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C5IdEXCXs8zXZcYmvyTRR1ni3BLKvWsIoaGSmqz052g='
WHERE
key_id = '0dc04e5e4ddff27e2e36e3146909bdafdb19c33b3de6a186de4b4e42fa7daf1b'
AND (
token = 'C5IdEXCXs8zXZcYmvyTRR1ni3BLKvWsIoaGSmqz052g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)