UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Cd+HsXxNKKlKcfhujDt4G6F13/r+4iHsjCvt+4sb2o='
WHERE
key_id = 'a9c91e218be04d65dab4bb4ce09c338b2e0be827ec3f66f5cb63e399f96bf01a'
AND (
token = '6Cd+HsXxNKKlKcfhujDt4G6F13/r+4iHsjCvt+4sb2o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)