UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GXym7oUb6B7pO/YG6ecL7kCVa/ha807I6GBiV17qH7c='
WHERE
key_id = 'a1d39bc3d307efdd7746f1971d12722f80a0e0db16b0c53673fc9ad6bbcd6428'
AND (
token = 'GXym7oUb6B7pO/YG6ecL7kCVa/ha807I6GBiV17qH7c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)