UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wZDvoR/QfG9csVQnL3A2wolfTulDJAkIf8plBSj5sLE='
WHERE
key_id = '9fece32cdfc10bac9510321c2623298584279ce35f5174aea7833946c3b8a42b'
AND (
token = 'wZDvoR/QfG9csVQnL3A2wolfTulDJAkIf8plBSj5sLE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)