UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZCPlii7FkldIxU1bXd2qsWkblfxaT4ZWEMLlEiZpI0='
WHERE
key_id = 'decdb16593a108430cb65f6645164037abb75c020c61fdc7c92e89e1264d781a'
AND (
token = 'dZCPlii7FkldIxU1bXd2qsWkblfxaT4ZWEMLlEiZpI0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)