UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zdtp9CoA8BtoiYONKrQYSyuTFhLXV2qAKmIAh7RcY3Q='
WHERE
key_id = '7ef3f0d014a40d81d809014f3e46c7062a4bf782e00509dc7bb61fc191e527ae'
AND (
token = 'zdtp9CoA8BtoiYONKrQYSyuTFhLXV2qAKmIAh7RcY3Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)