UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gxkKj5e5fMImcSBxjL0gESJNXGOA1wwES79y7frJZvk='
WHERE
key_id = '863dbe720283c5903a501150db19e885820c10f62b79a8898c2733db1db239b8'
AND (
token = 'gxkKj5e5fMImcSBxjL0gESJNXGOA1wwES79y7frJZvk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)