UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+6MmpmXxkvLwAHqfGynxKcd9JR1lyxny39pT+E10LxA='
WHERE
key_id = '963a5475865f244046c67f837b64e1c5c69b92084e567c180a0d98ee85cf6421'
AND (
token = '+6MmpmXxkvLwAHqfGynxKcd9JR1lyxny39pT+E10LxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)