UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H4oM8s/+VYHIfO1tVHcZPPAGl2lzeZSSKCv2Td6/v9Q='
WHERE
key_id = 'bbb686f1ac00f5f10a1eea9fe5a840e812c7f7bb845724c3334352ea4d026edc'
AND (
token = 'H4oM8s/+VYHIfO1tVHcZPPAGl2lzeZSSKCv2Td6/v9Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)