UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MrChdTD96OtCkKvLULfc9mZOIiTV2O89BD3bGI+P7kA='
WHERE
key_id = '8b03e9a56bb54dc31fcb3f1fab7388168ead74c7eb15ce396eb999e683981596'
AND (
token = 'MrChdTD96OtCkKvLULfc9mZOIiTV2O89BD3bGI+P7kA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)