UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mlg0pUeVAdRX+HdGSRFBf91Jl/NeT1Q0YX/5Tww+ljY='
WHERE
key_id = '12748167e4713f7bc8040cfde749a710ecb5a6cc5ff04f23db72a8259be6cfa4'
AND (
token = 'mlg0pUeVAdRX+HdGSRFBf91Jl/NeT1Q0YX/5Tww+ljY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)