UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WBhSQY3UNbPzCaajctpo75CKIc75iXxuLbN/cvqFwuA='
WHERE
key_id = 'a035efe99a01c37efb29818b0257d530aa0b72187ff7a7b00b1e50b85789163f'
AND (
token = 'WBhSQY3UNbPzCaajctpo75CKIc75iXxuLbN/cvqFwuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)