UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xP3AkyYOinr6HbxQMk8085Re4q5IgrWxutzKhmZkBa0='
WHERE
key_id = '9f1077bd86af95c806eb49b39601002297e59b51a33e69b8d0abdbe4584b6d20'
AND (
token = 'xP3AkyYOinr6HbxQMk8085Re4q5IgrWxutzKhmZkBa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)