UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TGeK6nGo5F/81xNAoTjCuAZjyT3R3dvvViscCcDu1CU='
WHERE
key_id = '9a499db7d3ff50f443c27442ffd1bf7d831ae1110a68fd8beb869ae7747fe1e7'
AND (
token = 'TGeK6nGo5F/81xNAoTjCuAZjyT3R3dvvViscCcDu1CU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)