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