UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X7x7B1XrcZIsIvdg4qDatb6jsRjlNX/2UtGuaUFu1cA='
WHERE
key_id = 'ec35ba51fe976fc156f4337f3ebbd20fb9770a1ba38d033e949be3d5b778ef43'
AND (
token = 'X7x7B1XrcZIsIvdg4qDatb6jsRjlNX/2UtGuaUFu1cA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)