UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'slX4p5WnUKtj4BHlKy+VmO5UWUfzweAP6G34B+iaqa8='
WHERE
key_id = '3fef75d4013042faa9b565458fccfa52a1bc9b8e433e155a53f27c607b06cb19'
AND (
token = 'slX4p5WnUKtj4BHlKy+VmO5UWUfzweAP6G34B+iaqa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)