UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X0orCq1bY0WbtaXa4bcTazypP+/enHYa8+w/vuwJtC4='
WHERE
key_id = '409ec4127043b9049ccc8c6a06d11700ddedbd3c2f11b077c181abe522f1ea7a'
AND (
token = 'X0orCq1bY0WbtaXa4bcTazypP+/enHYa8+w/vuwJtC4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)