UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/WrVkEMZdQpc9tspHozwUH+a9djfIBOeWQ6EaABSwdg='
WHERE
key_id = 'e4472e001b52d31167d0a83064cb6827baf1c44e0c928e200fd5ef0a77360a43'
AND (
token = '/WrVkEMZdQpc9tspHozwUH+a9djfIBOeWQ6EaABSwdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)