UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IP5pqoQgbBfc8DRjgNQUU+WMoVG5Ue5b9gjoB5H1wBw='
WHERE
key_id = 'd93e31aaae99560a1ca379d189f188c92d12ffb8634d47bfbf0cea9e8b8eca2f'
AND (
token = 'IP5pqoQgbBfc8DRjgNQUU+WMoVG5Ue5b9gjoB5H1wBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)