UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NxCp1dIc2IOZYhn0iKA4S2R7O7Q+Qn3eyuqqFr74WNw='
WHERE
key_id = '77529719953fdbf536631ca021c5f14a47787d03769bf458310fe11fe465f674'
AND (
token = 'NxCp1dIc2IOZYhn0iKA4S2R7O7Q+Qn3eyuqqFr74WNw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)