UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NkgNFbXh162JsRl8WzuhEmpgsAExbOuX9zuaplJBmMg='
WHERE
key_id = '7caec3718c38d3f49c3cc1b14d1be1113ffadfcaefb7bc7f5912f5a9c60cb5dc'
AND (
token = 'NkgNFbXh162JsRl8WzuhEmpgsAExbOuX9zuaplJBmMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)