UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wz6dQ16aIGJVLYi7XpCoNQzBmahnBKju6NtbS7loSuU='
WHERE
key_id = 'c6707494fa66f342f2d5dd67f9d7cae26a23b339523a751436275325b5a67617'
AND (
token = 'wz6dQ16aIGJVLYi7XpCoNQzBmahnBKju6NtbS7loSuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)