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