UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9yCvREDe0nIkz8tH4vDiOWecUQ2PkxNHv2qKC7+Pn8='
WHERE
key_id = 'aeef76a69c546cb7f237bec4063d1a1f3cfdd39255c5956fd750b4f9a5c7a5f7'
AND (
token = 'a9yCvREDe0nIkz8tH4vDiOWecUQ2PkxNHv2qKC7+Pn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)