UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pb2Bz5MAQlPb1T/URmRM7N5KJE6OaDxXnFwfGFm2VkI='
WHERE
key_id = '538cc6d08b1528237719c74120554d078c0d9167222d160c4f309e3fb0b4cf59'
AND (
token = 'Pb2Bz5MAQlPb1T/URmRM7N5KJE6OaDxXnFwfGFm2VkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)