UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WaV9pXAMyBjXBqerKkX1XlPYfnIv3aDs9RKNNz1VhQw='
WHERE
key_id = '46199057fb9e7a1ad33526f456e693285d4cbe4f74c03bf461dfa23d00ba2654'
AND (
token = 'WaV9pXAMyBjXBqerKkX1XlPYfnIv3aDs9RKNNz1VhQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)