UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xv7kN9PmHdCYS7jXR0P6L0ek5tLl/MKQriPK/OS4ttM='
WHERE
key_id = 'f2c7ffadeea4185b5a81595de01cc0af5238c99786daf894f8973be93158108b'
AND (
token = 'xv7kN9PmHdCYS7jXR0P6L0ek5tLl/MKQriPK/OS4ttM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)