UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oA0Gvobn1BGKiVbBVcydOT523EFBDoGrSo8Aqjeeeo4='
WHERE
key_id = 'e3985c4a1a82da903aaa39904597761be00965804066b3225ff12793d77f28c6'
AND (
token = 'oA0Gvobn1BGKiVbBVcydOT523EFBDoGrSo8Aqjeeeo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)