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