UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NH4dZiqztjR/yGevWg40BgQTF5z7jy9kiV9u0t64NtA='
WHERE
key_id = 'b10973667c76eaa84c6596dd48b3f0efce481b7bf3fd35503b01123975fa84d8'
AND (
token = 'NH4dZiqztjR/yGevWg40BgQTF5z7jy9kiV9u0t64NtA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)