UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kL2xBySABTH05pX0PbnKBlSd45YcymcvmRiimyXBEes='
WHERE
key_id = '78b462a68e9a18f02a1497ff5a20ef2e209a3f4c05a37318498912efdb7c6e14'
AND (
token = 'kL2xBySABTH05pX0PbnKBlSd45YcymcvmRiimyXBEes='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)