UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LmmK21D5c3YgzAAvo7AiqVrQx3gfoKGastbnDiY4B/w='
WHERE
key_id = 'e1da04fd8a75e0ac7b1c25e153217ad1b0f0235c09814302739a73572e23e8bc'
AND (
token = 'LmmK21D5c3YgzAAvo7AiqVrQx3gfoKGastbnDiY4B/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)