UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NbnWq5uSgpXemW1hF8z3w+76SJKkTGm46hZvbc7uag='
WHERE
key_id = '5d2b7d9eeb2f65adcfaab9911d7fdd35efdb8e4e2f9b580a9fe198ff24c659f1'
AND (
token = '7NbnWq5uSgpXemW1hF8z3w+76SJKkTGm46hZvbc7uag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)