UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pkG5tAlE7BJXnuWlkDYS8ePzwTUlQnO7MdSuFb4UcQI='
WHERE
key_id = '754d9d7aebda2bdb30343ee474a86fe433d5d083906aa9679e0a5a96bd928976'
AND (
token = 'pkG5tAlE7BJXnuWlkDYS8ePzwTUlQnO7MdSuFb4UcQI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)