UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rNCEo77Q6T0E7+QJtAVzy5XkbYDb1GZIL76eO9HzbQI='
WHERE
key_id = '7447c247e9f53a21d0c4de31b69d6ffe6d8fcd4f50d2a089e48123f4ca2035a4'
AND (
token = 'rNCEo77Q6T0E7+QJtAVzy5XkbYDb1GZIL76eO9HzbQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)