UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iUUeBNtog4M9GTyOULYKPXsUPWPj2EMYo9NfkR6sMnw='
WHERE
key_id = '27fbc94207f3c0258c85cd5fe36331eaf827e271aa56a7d99685f52544bc768e'
AND (
token = 'iUUeBNtog4M9GTyOULYKPXsUPWPj2EMYo9NfkR6sMnw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)