UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QcV6UqII2LQcGsN9NaujRu4G5MbEGgB26z/a7cNgOsY='
WHERE
key_id = 'bd44047703714c33073b319cdcda5406a2a8ee8eb702a3c4c5b7fad2adc4217b'
AND (
token = 'QcV6UqII2LQcGsN9NaujRu4G5MbEGgB26z/a7cNgOsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)