UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rv6TknT6TtS0fa7UNVZGzv++K4b44nsXFwXJVF2ogiw='
WHERE
key_id = 'fa421429b8cacdf9a307e97c5a18e6bdf496d666d810a99404891688fa88277a'
AND (
token = 'rv6TknT6TtS0fa7UNVZGzv++K4b44nsXFwXJVF2ogiw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)