UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDNBhmUPYh/28xT4ooM3AEpbTgTUq48bPJuLpkF/1WM='
WHERE
key_id = 'f4891d4adbc8d3a371376e84985f2f090443c20ba46b99d6ed60a495a4a2b3c4'
AND (
token = 'zDNBhmUPYh/28xT4ooM3AEpbTgTUq48bPJuLpkF/1WM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)