UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z5kgOWewL75mgb74Tmk3MKiaMa0utX91F+y8F5pFugY='
WHERE
key_id = 'ee7c47341836f35539c6ffbb2a827631d8f4246a87eeb0e45a158f76953f6ca7'
AND (
token = 'z5kgOWewL75mgb74Tmk3MKiaMa0utX91F+y8F5pFugY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)