UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UvAImfjwEw4xqi75h8I0cZyEWmNTeBBeF+efvsWwYjY='
WHERE
key_id = 'b4041aedd7c7a9941e2d4667ae6a046cd1ea93091ff11bd635a462ee0ed12725'
AND (
token = 'UvAImfjwEw4xqi75h8I0cZyEWmNTeBBeF+efvsWwYjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)