UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qW6E9j0fLk2MVGQb1J2kxNpTUJJVbZgpYD+Kasu6Cw4='
WHERE
key_id = '766c1454e0a1088fc5200e1618604ffe1b34d84ef8811fddfe5199973fadfd72'
AND (
token = 'qW6E9j0fLk2MVGQb1J2kxNpTUJJVbZgpYD+Kasu6Cw4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)